Hi All, I designed SSIS package for loading data from Sql server to Oracle table.Inbetween source to destination I used LookUp Transformation for identifying duplicated records. If records are already exists in table I'm updating target table.The below is update statement that I used to update target table in OLEDB command. update gen_ijp.XX_HUBBLE_VAC_DET_STG_TBL set HUBBLE_ID = ?, TYPE_OF_JOB =? , WORK_TYPE=? , CLUSTER_DET =? , NUMBER_OF_POS =? , TOTAL_CLOSED_POS =? , NO_OF_POS_CLOSED_EXTLY =? , NO_OF_POS_CLOSED_INTLY=? , NO_INT_EXT =? , TITLE=? , KEY_RESPONSIBILITIES =? , INDENT_DATE =? , VERTICAL=? , BAND=? , DESIGNATION =? , COE=? , SDO=? , PROCESS=? , BUSINESS_FUNCTION =? , COST_CODE=? , REGION =? , LOCATION_DET =? , OTHER_LOCATION =? , SITE =? , SHIFT=? , PART_TIME_FULL_TIME=? , WEEKEND_OFF=? , FLEXIBLE_WORK_OPTION =? , DEGREE_TYPE =? , DEGREE_NAME=? , MIN_WORK_EXPERIENCE=? , INDUSTRY =? , SERVICE_AREA =? , FUNCTION_DETAILS =? , INDUSTRY_DETAILS=? , SERVICE_AREA_DETAILS=? , FUNCTION_FLAG=? , SERVICE_LEVEL_AGRMENT_SIGNED=? , SUPERVISOR_OHRID =? , HR_MANAGER_OHRID=? , BUSINESS_REQUIRED=? , PRODUCTION_START =? , INDENT_CLOSURE_DATE =? , PANCARD=? , PASSPORT =? , WORK_PERMIT=? , ONSITE_EXPERIENCE =? , LANGUAGES_REQUIRED =? , CERTIFICATION_REQUIRED =? , ADDITIONAL_REQUIREMENTS=? , PART_OF_FORECAST =? , PROCESS_FLAG=? , ERROR_DETAILS =? , CREATION_DATE=? , LAST_UPDATE_DATE =? where Hubble_ID=? In first execution of SSIS package data is populated into target table. When I try to execute next time as per logic data need to update,but it gives error like "[OLE DB Command [359]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E10.An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80040E10 Description: "ORA-01008: not all variables bound"." Regards, Praveen C Regards, Praveen

What is the difference between the 1st and any subsequent runs? I think it is explained here: http://www.dba-oracle.com/t_ora_01008_plsql_variables_bound.htm Not all input vars have a value passed toArthur My Blog